{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Race SPIN - NS ToT RC","Boats","Course","RSinput","ScoreSheet"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[[17,0,17,14],[18,0,18,14],[19,0,19,14],[20,0,20,14],[21,0,21,14],[16,0,16,14],[0,0,0,14],[1,0,1,14],[2,0,2,14],[3,0,3,14],[4,0,4,14],[10,0,10,14],[11,0,11,14],[12,0,12,14],[13,0,13,14],[14,0,14,14],[15,0,15,14]]}
["Instructions:  Weekend Racing Worksheet"]
["ONLY Enter DATA In The SHADED Areas!!!!"]
["1. Select File - Save As, and Save with the \"File name\" as \"event<Date>\", eg \"SpringInvite19Apr20\"."]
["2. Select the Committee Boat Name (use pulldown) and Enter the Race Date."]
["3. Enter the Course (ENTER THE START MARK).  Use the Pulldown List.  The Course Length is automatically calculated."]
[null,"The Start location is assumed to be \"X\".  If the start location is moved then the distance must be manually calculated."]
[null,"If the course does not change for later starts, just leave the course selections blank for those starts.  "]
[null,"If later starts have a different course, enter the new course for each start that is different.  "]
["4. Select PHRF Course type:  W/L Or CR (Mostly Windward Leward -W/L or Circular Random (CR) for a mix that includes "]
[null,"windward, reaching, and leward).  Competitiors must be informed of selection prior to Warning!"]
["5. Enter each Yacht Name for the appropriate start.  Use the pulldown list.  The Sail Number and PHRF Rating is automatically   "]
["    completed.  If a Yacht Name is NOT in the pull down list, inquire about their race application and race fees. "]
["6. If the Start Time is different than the default, enter the New Start Time in 24-hour military format: (hr) (min) (sec)."]
["7. Save the File."]
["8. Enter the Finish Time for each boat in 24-hour military format: (hr) (min) (sec). "]
["     If a boat is DNS or DNF, leave the Finish Time as 23:00:00.  Enter the DNS or DNF in the Remarks column to the right of Corrected Time."]
["9. Save the File."]
["10. Select the Sort Fleet Button for each Class, located to the right of each Class's Remarks column."]
["11. Save the File."]
["12. Email the File to the Scorer at score@smsa.com"]
[]
["V 2020.WeekEnd.01     - PHRF Boats as of  11/11/19  - 2020 pending  "]
[]
["  Notes/changes:",null," 01 - Marks updated to 2022 SIs"]
[]
[]
[]
[]
[]
[]
["PHRF Race Type:",null,"WL",null,"Mostly Windward Leward Course type"]
[null,null,"CR",null,"All points of sail, or equal/greater ratio of Reaching to W/L"]
[null,null,"NSWL",null,"NonSpin Class: Mostly Windward Leward Course type"]
[null,null,"NSCR",null,"NonSpin Class: All points of sail, or equal/greater ratio of Reaching to W/L"]

{"sheet":"Race SPIN - NS ToT RC","index":1,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":false,"merged":[[31,2,31,3],[32,2,32,3],[32,4,32,5],[34,9,34,11],[34,14,34,18],[35,4,35,6],[35,9,35,11],[35,14,35,18],[9,9,9,11],[9,14,9,18],[10,4,10,6],[10,9,10,11],[10,14,10,18],[30,1,30,3],[2,3,2,7],[3,3,3,5],[4,3,4,19],[5,1,5,3],[6,2,6,3],[7,2,7,3],[7,4,7,5]]}
[]
["   Race Name :  --->"]
["  Committee Boat Name -->  "]
[null," Date  -->"]
[null," Conditions --> (optional)"]
[null,"NonSpin Class - Start =    ",null,null,13,5,0]
[null,null,"  Course   =      ",null,"Y",null,null,null,null,null,null,null,null,null,"<--  Default start location is 'X'."]
[null,null,"  Distance  =   ",null,{"$f":"IF(ISBLANK(F7), 0, VLOOKUP(E7,Course!$A$23:$T$41, LOOKUP(F7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(G7), 0, VLOOKUP(F7,Course!$A$23:$T$41, LOOKUP(G7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(J7), 0, VLOOKUP(G7,Course!$A$23:$T$41, LOOKUP(J7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(K7), 0, VLOOKUP(J7,Course!$A$23:$T$41, LOOKUP(K7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(L7), 0, VLOOKUP(K7,Course!$A$23:$T$41, LOOKUP(L7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(M7), 0, VLOOKUP(L7,Course!$A$23:$T$41, LOOKUP(M7,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))","v":0},null,null,null,null,null,null,null,null,null,"<--  Override Distance for W/L or Distance Race"]
[null,null,"PHRF Type =  ",null,"NSCR"]
[null,null,null,null,null,null,null,null,null,"Uncorrected",null,null,null,"PHRF","Corrected"]
[null,"Sail","Yacht","PHRF","Finish Time",null,null,null,null,"Elapsed Time",null,null,null,"Allowance","Time",null,null,null,null,"Remarks"]
[null,"Number","Name","Rating","(hr)","(min)","(sec)",null,null,"(hr)","(min)","(sec)",null,"(Sec)","(Total Sec)",null,"(hr)","(min)","(sec)","(DNS/DNF)"]
[null,{"$f":"LOOKUP(C13, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C13, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C13, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E13*60*60+F13*60+G13)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J13*60*60+K13*60","v":35700},{"$f":"ROUNDDOWN(H13/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H13 - (J13*60*60))/60, 0)","v":55},{"$f":"H13-I13","v":0},null,{"$f":"650/(550+$D13)","v":{"$error":"#N/A"}},{"$f":"((J13*60+K13)*60+L13)*N13","v":{"$error":"#N/A"}},{"$f":"Q13*60*60+R13*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O13/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O13 - (Q13*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O13-P13","v":{"$error":"#N/A"}}]
[1,{"$f":"LOOKUP(C14, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C14, Boats!$A$3:E$45,Boats!H$3:H$45),(IF(E$9=\"NSCR\",LOOKUP(C14, Boats!$A$3:E$45,Boats!I$3:I$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E14*60*60+F14*60+G14)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J14*60*60+K14*60","v":35700},{"$f":"ROUNDDOWN(H14/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H14 - (J14*60*60))/60, 0)","v":55},{"$f":"H14-I14","v":0},null,{"$f":"650/(550+$D14)","v":{"$error":"#N/A"}},{"$f":"((J14*60+K14)*60+L14)*N14","v":{"$error":"#N/A"}},{"$f":"Q14*60*60+R14*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O14/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O14 - (Q14*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O14-P14","v":{"$error":"#N/A"}}]
[3,{"$f":"LOOKUP(C15, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C15, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C15, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E15*60*60+F15*60+G15)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J15*60*60+K15*60","v":35700},{"$f":"ROUNDDOWN(H15/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H15 - (J15*60*60))/60, 0)","v":55},{"$f":"H15-I15","v":0},null,{"$f":"650/(550+$D15)","v":{"$error":"#N/A"}},{"$f":"((J15*60+K15)*60+L15)*N15","v":{"$error":"#N/A"}},{"$f":"Q15*60*60+R15*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O15/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O15 - (Q15*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O15-P15","v":{"$error":"#N/A"}}]
[4,{"$f":"LOOKUP(C16, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C16, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C16, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E16*60*60+F16*60+G16)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J16*60*60+K16*60","v":35700},{"$f":"ROUNDDOWN(H16/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H16 - (J16*60*60))/60, 0)","v":55},{"$f":"H16-I16","v":0},null,{"$f":"650/(550+$D16)","v":{"$error":"#N/A"}},{"$f":"((J16*60+K16)*60+L16)*N16","v":{"$error":"#N/A"}},{"$f":"Q16*60*60+R16*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O16/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O16 - (Q16*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O16-P16","v":{"$error":"#N/A"}}]
[5,{"$f":"LOOKUP(C17, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C17, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C17, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E17*60*60+F17*60+G17)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J17*60*60+K17*60","v":35700},{"$f":"ROUNDDOWN(H17/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H17 - (J17*60*60))/60, 0)","v":55},{"$f":"H17-I17","v":0},null,{"$f":"650/(550+$D17)","v":{"$error":"#N/A"}},{"$f":"((J17*60+K17)*60+L17)*N17","v":{"$error":"#N/A"}},{"$f":"Q17*60*60+R17*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O17/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O17 - (Q17*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O17-P17","v":{"$error":"#N/A"}}]
[6,{"$f":"LOOKUP(C18, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C18, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C18, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E18*60*60+F18*60+G18)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J18*60*60+K18*60","v":35700},{"$f":"ROUNDDOWN(H18/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H18 - (J18*60*60))/60, 0)","v":55},{"$f":"H18-I18","v":0},null,{"$f":"650/(550+$D18)","v":{"$error":"#N/A"}},{"$f":"((J18*60+K18)*60+L18)*N18","v":{"$error":"#N/A"}},{"$f":"Q18*60*60+R18*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O18/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O18 - (Q18*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O18-P18","v":{"$error":"#N/A"}}]
[7,{"$f":"LOOKUP(C19, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C19, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C19, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E19*60*60+F19*60+G19)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J19*60*60+K19*60","v":35700},{"$f":"ROUNDDOWN(H19/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H19 - (J19*60*60))/60, 0)","v":55},{"$f":"H19-I19","v":0},null,{"$f":"650/(550+$D19)","v":{"$error":"#N/A"}},{"$f":"((J19*60+K19)*60+L19)*N19","v":{"$error":"#N/A"}},{"$f":"Q19*60*60+R19*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O19/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O19 - (Q19*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O19-P19","v":{"$error":"#N/A"}}]
[8,{"$f":"LOOKUP(C20, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C20, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C20, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E20*60*60+F20*60+G20)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J20*60*60+K20*60","v":35700},{"$f":"ROUNDDOWN(H20/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H20 - (J20*60*60))/60, 0)","v":55},{"$f":"H20-I20","v":0},null,{"$f":"650/(550+$D20)","v":{"$error":"#N/A"}},{"$f":"((J20*60+K20)*60+L20)*N20","v":{"$error":"#N/A"}},{"$f":"Q20*60*60+R20*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O20/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O20 - (Q20*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O20-P20","v":{"$error":"#N/A"}}]
[9,{"$f":"LOOKUP(C21, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C21, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C21, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E21*60*60+F21*60+G21)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J21*60*60+K21*60","v":35700},{"$f":"ROUNDDOWN(H21/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H21 - (J21*60*60))/60, 0)","v":55},{"$f":"H21-I21","v":0},null,{"$f":"650/(550+$D21)","v":{"$error":"#N/A"}},{"$f":"((J21*60+K21)*60+L21)*N21","v":{"$error":"#N/A"}},{"$f":"Q21*60*60+R21*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O21/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O21 - (Q21*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O21-P21","v":{"$error":"#N/A"}}]
[10,{"$f":"LOOKUP(C22, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C22, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C22, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E22*60*60+F22*60+G22)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J22*60*60+K22*60","v":35700},{"$f":"ROUNDDOWN(H22/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H22 - (J22*60*60))/60, 0)","v":55},{"$f":"H22-I22","v":0},null,{"$f":"650/(550+$D22)","v":{"$error":"#N/A"}},{"$f":"((J22*60+K22)*60+L22)*N22","v":{"$error":"#N/A"}},{"$f":"Q22*60*60+R22*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O22/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O22 - (Q22*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O22-P22","v":{"$error":"#N/A"}}]
[11,{"$f":"LOOKUP(C23, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C23, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C23, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E23*60*60+F23*60+G23)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J23*60*60+K23*60","v":35700},{"$f":"ROUNDDOWN(H23/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H23 - (J23*60*60))/60, 0)","v":55},{"$f":"H23-I23","v":0},null,{"$f":"650/(550+$D23)","v":{"$error":"#N/A"}},{"$f":"((J23*60+K23)*60+L23)*N23","v":{"$error":"#N/A"}},{"$f":"Q23*60*60+R23*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O23/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O23 - (Q23*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O23-P23","v":{"$error":"#N/A"}}]
[12,{"$f":"LOOKUP(C24, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C24, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C24, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E24*60*60+F24*60+G24)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J24*60*60+K24*60","v":35700},{"$f":"ROUNDDOWN(H24/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H24 - (J24*60*60))/60, 0)","v":55},{"$f":"H24-I24","v":0},null,{"$f":"650/(550+$D24)","v":{"$error":"#N/A"}},{"$f":"((J24*60+K24)*60+L24)*N24","v":{"$error":"#N/A"}},{"$f":"Q24*60*60+R24*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O24/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O24 - (Q24*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O24-P24","v":{"$error":"#N/A"}}]
[13,{"$f":"LOOKUP(C25, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C25, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C25, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E25*60*60+F25*60+G25)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J25*60*60+K25*60","v":35700},{"$f":"ROUNDDOWN(H25/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H25 - (J25*60*60))/60, 0)","v":55},{"$f":"H25-I25","v":0},null,{"$f":"650/(550+$D25)","v":{"$error":"#N/A"}},{"$f":"((J25*60+K25)*60+L25)*N25","v":{"$error":"#N/A"}},{"$f":"Q25*60*60+R25*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O25/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O25 - (Q25*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O25-P25","v":{"$error":"#N/A"}}]
[14,{"$f":"LOOKUP(C26, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C26, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C26, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E26*60*60+F26*60+G26)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J26*60*60+K26*60","v":35700},{"$f":"ROUNDDOWN(H26/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H26 - (J26*60*60))/60, 0)","v":55},{"$f":"H26-I26","v":0},null,{"$f":"650/(550+$D26)","v":{"$error":"#N/A"}},{"$f":"((J26*60+K26)*60+L26)*N26","v":{"$error":"#N/A"}},{"$f":"Q26*60*60+R26*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O26/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O26 - (Q26*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O26-P26","v":{"$error":"#N/A"}}]
[15,{"$f":"LOOKUP(C27, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C27, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C27, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E27*60*60+F27*60+G27)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J27*60*60+K27*60","v":35700},{"$f":"ROUNDDOWN(H27/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H27 - (J27*60*60))/60, 0)","v":55},{"$f":"H27-I27","v":0},null,{"$f":"650/(550+$D27)","v":{"$error":"#N/A"}},{"$f":"((J27*60+K27)*60+L27)*N27","v":{"$error":"#N/A"}},{"$f":"Q27*60*60+R27*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O27/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O27 - (Q27*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O27-P27","v":{"$error":"#N/A"}}]
[16,{"$f":"LOOKUP(C28, Boats!$A$3:B$45,Boats!B$3:B$45)&NSFLAG","v":{"$error":"#N/A"}},null,{"$f":"IF(E$9=\"NSWL\",LOOKUP(C28, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$9=\"NSCR\",LOOKUP(C28, Boats!$A$3:E$45,Boats!F$3:F$45),)))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E28*60*60+F28*60+G28)-(E$6*60*60+F$6*60+G$6))","v":35700},{"$f":"J28*60*60+K28*60","v":35700},{"$f":"ROUNDDOWN(H28/60/60, 0)","v":9},{"$f":"ROUNDDOWN((H28 - (J28*60*60))/60, 0)","v":55},{"$f":"H28-I28","v":0},null,{"$f":"650/(550+$D28)","v":{"$error":"#N/A"}},{"$f":"((J28*60+K28)*60+L28)*N28","v":{"$error":"#N/A"}},{"$f":"Q28*60*60+R28*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O28/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O28 - (Q28*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O28-P28","v":{"$error":"#N/A"}}]
[]
[]
[null,"Spin  Fleet   - Start =    "]
[null,null,"  Course   =      ",null,null,null,null,null,null,null,null,null,null,null,"Leave course blank if the same as prior section start"]
[null,null,"  Distance  =   ",null,{"$f":"IF(ISBLANK(F32), E8, VLOOKUP(E32,Course!$A$23:$T$41, LOOKUP(F32,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(G32), 0, VLOOKUP(F32,Course!$A$23:$T$41, LOOKUP(G32,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(J32), 0, VLOOKUP(G32,Course!$A$23:$T$41, LOOKUP(J32,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(K32), 0, VLOOKUP(J32,Course!$A$23:$T$41, LOOKUP(K32,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(L32), 0, VLOOKUP(K32,Course!$A$23:$T$41, LOOKUP(L32,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))+IF(ISBLANK(M32), 0, VLOOKUP(L32,Course!$A$23:$T$41, LOOKUP(M32,Course!$A$2:$A$19,Course!$B$2:$B$19),FALSE))","v":0}]
[null,null,"PHRF Type =  ",null,"CR"]
[null,null,null,null,null,null,null,null,null,"Uncorrected",null,null,null,"PHRF","Corrected"]
[null,"Sail","Yacht","PHRF","Finish Time",null,null,null,null,"Elapsed Time",null,null,null,"Allowance","Time",null,null,null,null,"Remarks"]
[null,"Number","Name","Rating","(hr)","(min)","(sec)",null,null,"(hr)","(min)","(sec)",null,"(Sec)","(Total Sec)",null,"(hr)","(min)","(sec)","(DNS/DNF)"]
[1,{"$f":"LOOKUP(C38, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C38, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C38, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C38, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,{"$f":"((E38*60*60+F38*60+G38)-(E$31*60*60+F$31*60+G$31))","v":82800},{"$f":"J38*60*60+K38*60","v":82800},{"$f":"ROUNDDOWN(H38/60/60, 0)","v":23},{"$f":"ROUNDDOWN((H38 - (J38*60*60))/60, 0)","v":0},{"$f":"H38-I38","v":0},null,{"$f":"650/(550+$D38)","v":{"$error":"#N/A"}},{"$f":"((J38*60+K38)*60+L38)*N38","v":{"$error":"#N/A"}},{"$f":"Q38*60*60+R38*60","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN(O38/60/60, 0)","v":{"$error":"#N/A"}},{"$f":"ROUNDDOWN((O38 - (Q38*60*60))/60, 0)","v":{"$error":"#N/A"}},{"$f":"O38-P38","v":{"$error":"#N/A"}}]
[2,{"$f":"LOOKUP(C39, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C39, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C39, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C39, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$f":"((J39*60+K39)*60+L39)*N39","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[3,{"$f":"LOOKUP(C40, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C40, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C40, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C40, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,{"$f":"LOOKUP(C41, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C41, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C41, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C41, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,{"$f":"LOOKUP(C42, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C42, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C42, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C42, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,{"$f":"LOOKUP(C43, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C43, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C43, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C43, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,{"$f":"LOOKUP(C44, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C44, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C44, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C44, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,{"$f":"LOOKUP(C45, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C45, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C45, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C45, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,{"$f":"LOOKUP(C46, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C46, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C46, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C46, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,{"$f":"LOOKUP(C47, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C47, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C47, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C47, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[11,{"$f":"LOOKUP(C48, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C48, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C48, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C48, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[12,{"$f":"LOOKUP(C49, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C49, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C49, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C49, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[13,{"$f":"LOOKUP(C50, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C50, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C50, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C50, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[14,{"$f":"LOOKUP(C51, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C51, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C51, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C51, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[15,{"$f":"LOOKUP(C52, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C52, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C52, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C52, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[16,{"$f":"LOOKUP(C53, Boats!$A$3:B$45,Boats!B$3:B$45)","v":{"$error":"#N/A"}},null,{"$f":"IF(E$34=\"NS\",LOOKUP(C53, Boats!$A$3:E$45,Boats!I$3:I$45),(IF(E$34=\"WL\",LOOKUP(C53, Boats!$A$3:E$45,Boats!F$3:F$45),(IF(E$34=\"CR\",LOOKUP(C53, Boats!$A$3:E$45,Boats!G$3:G$45))))))","v":{"$error":"#N/A"}},23,0,0,82800,82800,23,0,0,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Boats","index":2,"n_rows":117,"n_cols":22,"rows_kept":117,"cut":false,"hidden":false,"merged":[[0,5,0,8]]}
[null,"N",null,null,null,"PHRF"]
["Boat","SailNo","Owner","Valid List 2022","email","Spin - WL","Spin - CR","NonSpin-WL","NonSpin-CR","Race Fee","Spinclass","I","J","P","E","LOA","LWL","Disp","UpSAD","DWSAD","DLWL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V4:V52)","v":15}]
["American Flyer",39519,"Dan Schneider","Y","dc_schneider@msn.com",36,33,42,42,"yes","A",51.25,14.04,50.45,18.47,39.4,34.119999999999997,13000,29.96,63.34,146.10607247052599]
["Arctic Tern",93642,"PAX","Y",null,168,168,168,168,"no","C",null,null,null,null,null,null,null,null,null,null,1]
["Bad Cat","063","Jim Whited","Y","jimw625@comcast.net",36,30,42,42,"yes","A",48.36,13.84,45.17,45.17,36.5,32.700000000000003,9300,23.92,70.47,118.74,1]
["Badger",144,"Carl Feusaherns","N","feus@comcast.net",177,177,177,177,"yes","C",30.5,9.5,29.42,12.29,25.9,21.7,4250,19.829999999999998,41.94,185.68,1]
["Barba Roja",73052,"Steven Birchfield","Y",null,165,168,165,168,null,"C"]
["Barefoot","36-2 WK","Brent Griffith","Y",null,"N/A","N/A",141,144,null,"B"]
["Blue Boat Home",4856,"Lowell Martin","N",null,231,231,231,231,"no","C",34,11.25,28.67,10.5,26.8,21.8,6850,15.14,35.43,295.17,1]
["Blue Goose",93643,"PAX","N",null,168,168,168,168,"no","C"]
["C2 (squared)",720,"Chris  Staley",null,null,189,192,189,192,null,"C"]
["Cheetah",50473,"Marc Briere","Y","race@smsa.com",45,39,54,54,"yes","A",43.7,12.6,44.7,16.5,35.86,31.76,8150,25.41,73.319999999999993,113.14,1]
["CROCODILE","USA 61150 ","Scott Ward","Y",null,27,24,27,24,null,"A"]
["Dauntless",52353,"Jim Keen","Y",null,90,87,90,90,null,"A"]
["Elan",43162,"Gary Shaw","Y","garyshaw75@aol.com",159,162,159,162,"no","C",49.5,15.33,42,11,36.83,29.5,13500,18.71,39.33,234.75762231915499,1]
["Elysium",45,null,null,null,84,84,84,84]
["Flyer",25126,"Michael Major","N","mjamesmajor@gmail.com",111,111,114,114,"no","B",40.18,11.65,42.27,15.79,34.4,27.2,8825,21.24,39.65,195.78]
["Gemini",3700,"Joe Frost",null,null,132,129,132,132]
["J Ray","USA47","Larry Ray","Y","mlray@gmail.com",114,111,120,120,"yes","B",26.77,7.68,26.16,9.44,22.8,20.5,1750,29.6,43,90.68,1]
["Juggernaut",51277,"David Ahearn","N",null,39,39,39,39,"no","A",50.82,14.7,51.75,16.5,37.700000000000003,34.200000000000003,11400,25.24,71.02,127.23]
["Lakahi",25260,"Jim Young","N","youngjw1203@earthlink.net",72,72,72,72,"yes","A",48,14.25,47,14.58,35.42,30,9800,26.64,50.21,162.03703703703701]
["Making Waves",53229,"Frederick Burger",null,null,174,177,174,177,null,"C"]
["Neptune's Wager",415,"Jerome Ball",null,null,153,153,153,153,null,"C"]
["One Trick Pony","US-188","David Meiser","Y",null,24,15,30,30,null,"A"]
["Patriot","USA25",null,null,null,54,45,63,63,null,"A"]
["Pony Express",50588,"Jimmy Yurko","Y","jimmydyurko@gmail.com",132,129,138,138,"yes","B",28,8.5,28,11,25,21.3,2000,27.49,61.72,92.39,1]
["Pursuit",23798,"Norm Dawley","Y","normdawley@norms-site.com",57,48,66,63,"yes","A",52,16,55,18,47.67,37.17,18689,20.66,49.83,162.07,1]
["Rakali",61145,"Mark Witte","Y","mcwitte@md.metrocast.net",51,45,54,51,"yes","A",40.6,13.5,41.5,14.6,34.5,29.5,7750,23.54,51.36,134.77000000000001,1]
["Shamal",23827,"Jeff Carlsen","Y",null,174,174,174,174,"yes","C",30.75,9.83,26.5,9.5,24.58,19.170000000000002,2950,23.78,46.61,187,1]
["SNUZULUZ",327,"Caldwell / McKinney","N",null,177,168,180,180,null,"C"]
["Spice",154,"H G","N",null,114,111,120,120,null,"B"]
["Splash","USA333","Tom Attick","N","tattick@chattick.com",90,87,96,96,"no","A",40.6,13.5,41.5,14.6,34.5,29.5,7750,23.54,51.36,134.77000000000001,1]
["Stingray",63383,"Elliot Peterson","Y","tepeterson@dcscorp.com",129,129,129,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,168.88508104322199,1]
["Stormy Petrel",93644,"PAX","N",null,168,168,168,168,"no","C"]
["Synergy",83096,"Peter LaRoche","Y",null,168,168,168,168,"yes","C"]
["Taerik",30410,"Mardy Miller",null,null,144,144,147,147]
["Tennacity",173,"Bill Ward","Y",null,111,111,111,111,null,"B"]
["TENNOUNCE ",99,"John McKinney","Y",null,180,180,180,180,null,"C"]
["The Doghouse",63199,"Dan Shannon","Y","shannon63199@verizon.net",111,111,111,111,"yes","B",40,12,35,12,29.5,25,6000,24.12,47.08,{"$f":"((R40/(2240*POWER((Q40/100),3))))","v":171.42857142857142},1]
["Triton's Fury",499,"T. J. O'Farrell","N","triton499@gmail.com",252,252,252,252,"no","C",31,10,32.979999999999997,12.83,28.5,20.5,8200,14.4,26.05,424.92]
["USA 4201",4201,"Terry Reese","Y",null,171,171,171,171,null,"C"]
["Whirlaway",73211,"Frank Walter","Y",null,114,114,114,114,"no","B"]
["Wicked Good",93121,"Mark Gyorgy","Y","mygorgy@dscorp.com",132,132,132,132,"yes","B",35.25,10.199999999999999,37.200000000000003,12,26.83,23.42,3800,29.81,51.7,132.06109868494099,1]
["Wild Horses","USA 222","McKinney, Caldwell","Y",null,24,15,30,30,null,"A"]
["Wild Thing",87638,"Jimmy Yurko","N","jimmydyurko@yahoo.com",186,186,186,186,"yes","C",22.6,7.25,24.04,9.33,20.329999999999998,18.420000000000002,1160,28.1,58.28,83.13]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Old Boat Data:"]
["American Flyer",39519,"Dan Schneider",null,"dc_schneider@msn.com",36,36,42,42,"yes","A",51.25,14.04,50.45,18.47,39.4,34.119999999999997,13000,29.96,63.34,146.10607247052599,1]
["Antagonist",217,"Eddie Sierra/Scott Roland",null,"ed.sierra347@gmail.com",114,111,120,120,"yes","B",26.77,7.68,26.16,9.44,22.8,20.5,1750,29.6,43,90.68,1]
["Arctic Tern",93642,"PAX",null,null,168,168,168,168,"no","C"]
["Audrey",764,"Trevor Harney",null,"Trevor.Harney@atkinsglobal.com",174,174,174,174,"no","C"]
["Bad Cat","063","Jim Whited",null,"jimw625@comcast.net",39,33,48,48,"yes","A",48.36,13.84,45.17,45.17,36.5,32.700000000000003,9300,26.65,73.27,119,1]
["Badger",144,"Carl Feusaherns",null,"feus@comcast.net",177,177,177,177,"yes","C",28.75,9.66,28,9.75,24.5,20.5,2900,24.11,46.03,150.27557431179,1]
["Blue Goose",93643,"PAX",null,null,168,168,168,168,"no","C"]
["Cheetah",50473,"Marc Briere",null,"race@smsa.com",36,36,45,45,"yes","A",43.7,12.6,44.7,16.5,35.86,31.76,8150,28.76,70.08,114,1]
["Deju Vue",41299,"Douglas Aulson",null,null,147,147,147,147,"yes","B"]
["Easy Button",93084,"David Meiser",null,"meiser@comcast.net",159,159,159,159,"yes","C",27.75,8.25,29.75,11.72,25.7,20,2600,27.79,46.9,145.08928571428601,1]
["Elan",43162,"Gary Shaw",null,"garyshaw75@aol.com",153,153,153,153,"yes","C",49.5,15.33,42,11,36.83,29.5,13500,18.71,39.33,234.75762231915499,1]
["Flyer",25126,"Michael Major",null,"mjamesmajor@gmail.com",111,111,114,114,"yes","B",40.18,11.65,42.27,15.79,34.4,27.2,8825,21.24,39.65,195.78,1]
["Gift Horse",87012,"Jimmy Yurko",null,"jimmydyurko@gmail.com",111,111,111,111,"yes","B",null,null,null,null,null,null,null,null,null,null,1]
["Hellcat",52994,"Jim Keen","Y",null,96,99,102,105,"yes","A"]
["J Ray","USA47","Larry Ray",null,"mlray@gmail.com",114,114,120,120,"yes","B",26.77,7.68,26.16,9.44,22.8,20.5,1750,29.6,43,90.68,1]
["Krugerrand",53477,"Sarah Southworth","N","write2ss@cs.com",132,132,132,132,"no","B",48.42,14.33,42.33,13,36.17,29.42,15300,17.77,35.47,{"$f":"((R84/(2240*POWER((Q84/100),3))))","v":268.2349766677014},1]
["Lakahi",25260,"Jim Young",null,"youngjw1203@earthlink.net",72,72,72,72,"no","A",48,14.25,47,14.58,35.42,30,9800,26.64,50.21,162.03703703703701]
["Lickety Split",43067,"Donna Maneely","Y","damaneely@verizon.net",168,168,168,168,"no","C",40.86,13,35.36,11.79,31.71,25,9400,18.73,33.700000000000003,268.57142857142901,1]
["Natural Disaster",63243,"Thomas Moulds","N","tmoulds@dtiweb.net",114,114,114,114,"yes","B",36,11.75,31.5,10.75,30,27.5,3600,28.56,57.33,{"$f":"((R87/(2240*POWER((Q87/100),3))))","v":77.278093807019403},1]
["Pony Express",50588,"Jimmy Yurko",null,"jimmydyurko@gmail.com",132,129,138,138,"yes","B",28,8.5,28,11,25,21.3,2000,27.49,61.72,92.39,1]
["Pursuit",23798,"Norm Dawley",null,"normdawley@norms-site.com",51,45,66,66,"yes","A",52,16,55,18,47.67,37.17,18689,23.26,45.15,162.46520482011201,1]
["Rakali","USAxxx","Mark Witte",null,"mcwitte@md.metrocast.net",90,90,96,96,"yes","A"]
["Rhumb Punch",26007,"John Edwards",null,"rhumbpunch@msn.com",81,81,90,90,"yes","A"]
["Shamal",23827,"Jeff Carlsen",null,null,174,174,174,174,"yes","C",30.75,9.83,26.5,9.5,24.58,19.170000000000002,2950,23.78,46.61,187,1]
["Shermax",2276,"Max Munger","Y","maxmunger@verizon.net",177,177,177,177,"no","C",43,13.16,37.5,12,29.91,25,10200,19.02,37.85,291.42857142857099]
["Short Bus",71221,"Hawk Caldwell","Y","hawkcaldwell@gmail.com",45,36,54,54,"yes","A",36.71,10.99,38.630000000000003,14.38,30.8,28.3,4028,36.86,92.16,79.34,1]
["Spinnster",161,"Betsy Dodge","N","bdodge33@comcast.net",171,171,171,171,"yes","C",30.5,9.5,29.5,12.25,25.92,21.67,4250,22.36,39.880000000000003,186.45076850448501,1]
["Splash","USA xxx","Tom Attick",null,"tattick@chattick.com",90,90,96,96,"yes","A"]
["Stingray",63383,"Elliot Peterson",null,"tepeterson@dcscorp.com",129,129,129,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,168.88508104322199,1]
["Stormy Petrel",93644,"PAX",null,null,168,168,168,168,"no","C"]
["Supra",30023,"Peter D'Arista","N","peterd@toyotamd.com",48,48,57,57,"no","A",30.3,9.6,33,12.8,26,24.7,2447,31.39,99.92,72.489999999999995,1]
["Supra Turbo",2610,"Peter D'Arista",null,"peterd@toyotamd.com",78,78,87,87,"Yes","A"]
["The Doghouse",63199,"Dan Shannon",null,"shannon63199@verizon.net",111,111,111,111,"yes","B",40,12,35,12,29.5,25,6000,24.12,47.08,{"$f":"((R101/(2240*POWER((Q101/100),3))))","v":171.42857142857142},1]
["Valiant",60177,"John Durniak",null,"johndurniak@yahoo.com",93,93,93,93,"no","A",58.71,18.45,50.75,16,44,35.799999999999997,31641,16.63,33.83,{"$f":"((R102/(2240*POWER((Q102/100),3))))","v":307.8598847550997}]
["Wicked Good",93121,"Mark Gyorgy",null,"mygorgy@dscorp.com",132,132,132,132,"yes","B",35.25,10.199999999999999,37.200000000000003,12,26.83,23.42,3800,29.81,51.7,132.06109868494099,1]
["Spinnster",161,"Betsy Dodge",null,"bdodge33@comcast.net",171,null,null,null,"yes","C",30.5,9.5,29.5,12.25,25.92,21.67,4250,22.36,39.880000000000003,{"$f":"((R104/(2240*POWER((Q104/100),3))))","v":186.45076850448498}]
["Splash","USA 173","Tom Attick",null,"tattick@chattick.com",111,null,null,111,"yes","B",40,12,35,12,29.5,25,5500,25.56,49.85,157.14285714285714]
["Status Quo",63076,"Jimmy Yurko",null,"jimmydyurko@yahoo.com",108,null,null,108,"yes","A",36,11.75,31.5,10.75,30,27.5,3750,27.8,55.79,80.498014382311879]
["Stingray",63383,"Elliot Peterson",null,"tepeterson@dcscorp.com",129,null,null,129,"yes","B",38,10.95,32.4,12,27.9,23.8,5100,24.12,45.56,168.88508104322156]
["Synergy",83096,"Peter LaRoche",null,"no email",168,null,null,168,"no","C",39,12.5,34.25,11.5,29.96,25.25,7950,19.5,37.94,220.46261931499356]
["Tenounce",99,"John Mckinney",null,"no email",null,null,null,174,"no","C",41.5,13.87,35,13.75,33.17,26.25,10500,19.46,19.46,259.1512795594428]
["The Doghouse",63199,"Dan Shannon",null,"shannon63199@verizon.net",111,null,null,111,"yes","B",40,12,35,12,29.5,25,6000,24.12,47.08,171.42857142857142]
["The Riddler",63243,"Clarke McKinney",null,"cmckinney@quantumsails.com",108,null,null,114,"yes","A",34,11,32.5,11.5,29.67,27.5,3600,28.36,58.78,77.278093807019403]
["Toby",142,"Chris Eggert",null,"christopher.eggert@navy.mil",141,null,null,141,"yes","B",47.5,15,41.75,11.5,36,29,12800,19.03,37.770000000000003,234.29766346655111]
["Valiant",60177,"L. Allen, Navy PAX SC",null,"robert@luckritz.com",93,null,null,93,"yes *","A",58.71,18.45,50.75,16,44,35.799999999999997,31641,16.63,33.83,307.8598847550997]
["Whiskers",63063,"Jim Whited",null,"jimw625@comcast.net",96,null,null,96,"yes","A",50.9,15.16,44.1,13.1,37,30.32,12938,21.49,42.34,207.21993712386671]
["Wicked Good",93121,"Mark Gyorgy",null,"mygorgy@dscorp.com",132,null,null,132,"yes","B",35.25,10.199999999999999,37.200000000000003,12,26.83,23.42,3800,29.81,51.7,132.06109868494102]
["Wild Thing",87638,"Jimmy Yurko",null,"jimmydyurko@yahoo.com",183,null,null,186,"yes","C",22.6,7.25,24.04,9.33,20.329999999999998,18.420000000000002,1160,31.82,54.07,82.859268190743165]
["Family Truckster","USA788","Clarke Mckinney",null,"cmckinney@quantumsails.com",120,null,null,129,"no","B",31.5,9.5,30,12.5,26.25,22,2900,29.88,72.56,121.585542556617]

{"sheet":"Course","index":3,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[null,20,20,null,null,null,20,20,null,null,20,20]
[null,20,20,null,null,"A",2,2,null,"A",2,2,null,"Page has been customized for Wednesday night MARKS"]
["A",2,2,null,null,"B",3,3,null,"B",3,3]
["B",3,3,null,null,"C",4,4,null,"E",5,5]
["C",4,4,null,null,"E",5,5,null,"K",10,10]
["G",6,6,null,null,"G",6,6,null,"L",11,11]
["H",7,7,null,null,"H",7,7,null,"M",12,12]
["I",8,8,null,null,"I",8,8,null,"S",17,17]
["J",9,9,null,null,"J",9,9,null,"T",14,14]
["K",10,10,null,null,"K",10,10,null,"X",16,16]
["L",11,11,null,null,"L",11,11,null,"Y",18,18]
["M",12,12,null,null,"M",12,12,null,"Z",19,19]
["S",17,17,null,null,"S",17,17]
["T",14,14,null,null,"T",14,14]
["V",16,16,null,null,"V",16,16]
["X",16,16,null,null,"X",16,16]
["Y",18,18,null,null,"Y",18,18]
["Z",19,19,null,null,"Z",19,19]
[null,"Active",null,null,null,null,"All",null,null,null,"Bay"]
[]
[]
[null,"A","B","C","E","G","H","I","J","K","L","M","N","T","U","V","S","Y","Z","X"]
["A",0,0.94,3.41,2.15,3.72,5.41,5.95,6.47,1.87,2.34,2.83,0,0.96,0,0.87,2.38,1.41,2.35,1.35]
["B",0.94,0,2.4700000000000002,1.28,2.82,4.47,5.01,5.53,2.8,3.19,3.71,0,1.58,0,1.82,3.19,2.17,3.11,2.15]
["C",3.41,2.4700000000000002,0,2.57,3.11,2.14,3.79,3.23,null,null,null,null,null,null,null,null,null,null,0]
["E",2.15,1.28,2.57,0,1.57,4.1399999999999997,4,5.09,null,null,null,null,null,null,null,null,null,null,0]
["G",3.72,2.82,3.11,1.57,0,3.85,2.7,4.57,null,null,null,null,null,null,null,null,null,null,0]
["H",5.41,4.47,2.14,4.1399999999999997,3.85,0,2.84,1.1000000000000001,null,null,null,null,null,null,null,null,null,null,0]
["I",5.95,5.01,3.79,4,2.7,2.84,0,2.87,null,null,null,null,null,null,null,null,null,null,0]
["J",6.47,5.53,3.23,5.09,4.57,1.1000000000000001,2.87,0,null,null,null,null,null,null,null,null,null,null,0]
["K",1.87,2.8,null,null,null,null,null,null,0,0.89,1.84,0,1.64,0,1.06,1.42,1.29,2.1,1.1299999999999999]
["L",2.34,3.19,null,null,null,null,null,null,0.89,0,1.01,0,1.72,0,1.73,0.76,1.2,1.86,1.1100000000000001]
["M",2.83,3.71,null,null,null,null,null,null,1.84,1.01,0,0,2.2400000000000002,0,2.4,0.56000000000000005,1.7,2.38,1.45]
["N",0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
["T",0.96,1.56,null,null,null,null,null,null,1.64,1.72,2.2400000000000002,0,0,0,1.23,1.73,0.69,1.62,0.65]
["U",0,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
["V",0.87,1.82,null,null,null,null,null,null,1.06,1.73,2.4,0,1.1599999999999999,0,0,1.89,1.23,2.13,1.0900000000000001]
["S",2.36,3.19,null,null,null,null,null,null,1.42,0.76,0.56000000000000005,0,1.73,null,1.89,0,1.2,1.86,1.1100000000000001]
["Y",1.41,2.17,null,null,null,null,null,null,1.29,1.2,1.7,0,0.69,0,1.23,1.2,0,0.94,0.15]
["Z",2.35,3.11,null,null,null,null,null,null,2.1,1.86,2.38,0,1.62,0,2.13,1.86,0.94,0,1.1499999999999999]
["X",1.35,2.15,0,0,0,0,0,0,1.1299999999999999,1.1100000000000001,1.45,0,0.65,0,1.0900000000000001,1.1100000000000001,0.15,1.1499999999999999,0]
[]
[]
[]
["Middle Distance Series Course Table"]
[null,null,null,null,"NS","Spin"]
["Sharps Island Race",null,null,null,39.9,39.9]
["Little Choptank Race",null,null,null,32.5,32.5]
["Smith Point Race",null,null,null,42,59]
["Hooper Island Point-No-Point Race",null,null,null,29.4,29.4]

{"sheet":"RSinput","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Sail","BoatName","PHRF",null,null,null,"Finish","Division"]
[null,null,null,null,null,null,{"$f":"TIME(D2,E2,F2)","v":"00:00:00"},"PHRF A"]
[null,null,null,null,null,null,"00:00:00","PHRF B"]
[null,null,null,null,null,null,"00:00:00","PHRF A"]
[null,null,null,null,null,null,"00:00:00","PHRF C"]
[null,null,null,null,null,null,"00:00:00","PHRF A"]
[null,null,null,null,null,null,"00:00:00","PHRF C"]
[null,null,null,null,null,null,"00:00:00","PHRF B"]
[null,null,null,null,null,null,"00:00:00","PHRF A"]
[null,null,null,null,null,null,"00:00:00","PHRF A"]
[null,null,null,null,null,null,"00:00:00","PHRF B"]
[null,null,null,null,null,null,"00:00:00","PHRF A"]
[null,null,null,null,null,null,"00:00:00","PHRF C"]
[null,null,null,null,null,null,"00:00:00","PHRF B"]
[null,null,null,null,null,null,"00:00:00","PHRF B"]
[null,null,null,null,null,null,"00:00:00","PHRF B"]
[null,null,null,null,null,null,"00:00:00","PHRF A"]
[null,null,null,null,null,null,"00:00:00","NonSpin"]
[null,null,null,null,null,null,"00:00:00","NonSpin"]
[null,null,null,null,null,null,"00:00:00","NonSpin"]

{"sheet":"ScoreSheet","index":5,"n_rows":53,"n_cols":15,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,2,2,4],[0,4,0,10],[2,13,2,14]]}
["SMSA Scoring Worksheet",null,null,null,"Race Name _________________________________"]
[null,"Date : ","_____________________",null,null,"RC: ",null,"____________________"]
[null,"Course: ","_______________________________________",null,null,null,null,null,null,null,null,"Finish time",null,"Order of Finish"]
["Boat","SailNo","Owner","Spin - WL","Spin - CR","NonSpin-WL","NonSpin-CR","Spinclass","Checked In",null,"(hr)","(min)","(sec)","Boat","Running Finish Time"]
[" "," "," "," "," "," ",null," "]
[{"$f":"[1]Boats!A4","v":"American Flyer"},{"$f":"[1]Boats!B4","v":39519},{"$f":"[1]Boats!C4","v":"Dan Schneider"},{"$f":"[1]Boats!F4","v":36},{"$f":"[1]Boats!G4","v":33},{"$f":"[1]Boats!H4","v":42},{"$f":"[1]Boats!I4","v":42},{"$f":"[1]Boats!K4","v":"A"}]
[{"$f":"[1]Boats!A5","v":"Arctic Tern"},{"$f":"[1]Boats!B5","v":93642},{"$f":"[1]Boats!C5","v":"PAX"},{"$f":"[1]Boats!F5","v":168},{"$f":"[1]Boats!G5","v":168},{"$f":"[1]Boats!H5","v":168},{"$f":"[1]Boats!I5","v":168},{"$f":"[1]Boats!K5","v":"C"}]
[{"$f":"[1]Boats!A6","v":"Bad Cat"},{"$f":"[1]Boats!B6","v":"063"},{"$f":"[1]Boats!C6","v":"Jim Whited"},{"$f":"[1]Boats!F6","v":36},{"$f":"[1]Boats!G6","v":30},{"$f":"[1]Boats!H6","v":42},{"$f":"[1]Boats!I6","v":42},{"$f":"[1]Boats!K6","v":"A"}]
[{"$f":"[1]Boats!A7","v":"Badger"},{"$f":"[1]Boats!B7","v":144},{"$f":"[1]Boats!C7","v":"Carl Feusaherns"},{"$f":"[1]Boats!F7","v":177},{"$f":"[1]Boats!G7","v":177},{"$f":"[1]Boats!H7","v":177},{"$f":"[1]Boats!I7","v":177},{"$f":"[1]Boats!K7","v":"C"}]
[{"$f":"[1]Boats!A8","v":"Barba Roja"},{"$f":"[1]Boats!B8","v":73052},{"$f":"[1]Boats!C8","v":"Steven Birchfield"},{"$f":"[1]Boats!F8","v":165},{"$f":"[1]Boats!G8","v":168},{"$f":"[1]Boats!H8","v":165},{"$f":"[1]Boats!I8","v":168},{"$f":"[1]Boats!K8","v":"C"}]
[{"$f":"[1]Boats!A9","v":"Barefoot"},{"$f":"[1]Boats!B9","v":"36-2 WK"},{"$f":"[1]Boats!C9","v":"Brent Griffith"},{"$f":"[1]Boats!F9","v":"N/A"},{"$f":"[1]Boats!G9","v":"N/A"},{"$f":"[1]Boats!H9","v":141},{"$f":"[1]Boats!I9","v":144},{"$f":"[1]Boats!K9","v":"B"}]
[{"$f":"[1]Boats!A10","v":"Blue Boat Home"},{"$f":"[1]Boats!B10","v":4856},{"$f":"[1]Boats!C10","v":"Lowell Martin"},{"$f":"[1]Boats!F10","v":231},{"$f":"[1]Boats!G10","v":231},{"$f":"[1]Boats!H10","v":231},{"$f":"[1]Boats!I10","v":231},{"$f":"[1]Boats!K10","v":"C"}]
[{"$f":"[1]Boats!A11","v":"Blue Goose"},{"$f":"[1]Boats!B11","v":93643},{"$f":"[1]Boats!C11","v":"PAX"},{"$f":"[1]Boats!F11","v":168},{"$f":"[1]Boats!G11","v":168},{"$f":"[1]Boats!H11","v":168},{"$f":"[1]Boats!I11","v":168},{"$f":"[1]Boats!K11","v":"C"}]
[{"$f":"[1]Boats!A12","v":"C2 (squared)"},{"$f":"[1]Boats!B12","v":720},{"$f":"[1]Boats!C12","v":"Chris  Staley"},{"$f":"[1]Boats!F12","v":189},{"$f":"[1]Boats!G12","v":192},{"$f":"[1]Boats!H12","v":189},{"$f":"[1]Boats!I12","v":192},{"$f":"[1]Boats!K12","v":"C"}]
[{"$f":"[1]Boats!A13","v":"Cheetah"},{"$f":"[1]Boats!B13","v":50473},{"$f":"[1]Boats!C13","v":"Marc Briere"},{"$f":"[1]Boats!F13","v":45},{"$f":"[1]Boats!G13","v":39},{"$f":"[1]Boats!H13","v":54},{"$f":"[1]Boats!I13","v":54},{"$f":"[1]Boats!K13","v":"A"}]
[{"$f":"[1]Boats!A14","v":"CROCODILE"},{"$f":"[1]Boats!B14","v":"USA 61150 "},{"$f":"[1]Boats!C14","v":"Scott Ward"},{"$f":"[1]Boats!F14","v":27},{"$f":"[1]Boats!G14","v":24},{"$f":"[1]Boats!H14","v":27},{"$f":"[1]Boats!I14","v":24},{"$f":"[1]Boats!K14","v":"A"}]
[{"$f":"[1]Boats!A15","v":"Dauntless"},{"$f":"[1]Boats!B15","v":52353},{"$f":"[1]Boats!C15","v":"Jim Keen"},{"$f":"[1]Boats!F15","v":90},{"$f":"[1]Boats!G15","v":87},{"$f":"[1]Boats!H15","v":90},{"$f":"[1]Boats!I15","v":90},{"$f":"[1]Boats!K15","v":"A"}]
[{"$f":"[1]Boats!A16","v":"Elan"},{"$f":"[1]Boats!B16","v":43162},{"$f":"[1]Boats!C16","v":"Gary Shaw"},{"$f":"[1]Boats!F16","v":159},{"$f":"[1]Boats!G16","v":162},{"$f":"[1]Boats!H16","v":159},{"$f":"[1]Boats!I16","v":162},{"$f":"[1]Boats!K16","v":"C"}]
[{"$f":"[1]Boats!A18","v":"Flyer"},{"$f":"[1]Boats!B18","v":25126},{"$f":"[1]Boats!C18","v":"Michael Major"},{"$f":"[1]Boats!F18","v":111},{"$f":"[1]Boats!G18","v":111},{"$f":"[1]Boats!H18","v":114},{"$f":"[1]Boats!I18","v":114},{"$f":"[1]Boats!K18","v":"B"}]
[{"$f":"[1]Boats!A19","v":"Gemini"},{"$f":"[1]Boats!B19","v":3700},{"$f":"[1]Boats!C19","v":"Joe Frost"},{"$f":"[1]Boats!F19","v":132},{"$f":"[1]Boats!G19","v":129},{"$f":"[1]Boats!H19","v":132},{"$f":"[1]Boats!I19","v":132},{"$f":"[1]Boats!K19","v":0}]
[{"$f":"[1]Boats!A20","v":"J Ray"},{"$f":"[1]Boats!B20","v":"USA47"},{"$f":"[1]Boats!C20","v":"Larry Ray"},{"$f":"[1]Boats!F20","v":114},{"$f":"[1]Boats!G20","v":111},{"$f":"[1]Boats!H20","v":120},{"$f":"[1]Boats!I20","v":120},{"$f":"[1]Boats!K20","v":"B"}]
[{"$f":"[1]Boats!A21","v":"Juggernaut"},{"$f":"[1]Boats!B21","v":51277},{"$f":"[1]Boats!C21","v":"David Ahearn"},{"$f":"[1]Boats!F21","v":39},{"$f":"[1]Boats!G21","v":39},{"$f":"[1]Boats!H21","v":39},{"$f":"[1]Boats!I21","v":39},{"$f":"[1]Boats!K21","v":"A"}]
[{"$f":"[1]Boats!A22","v":"Lakahi"},{"$f":"[1]Boats!B22","v":25260},{"$f":"[1]Boats!C22","v":"Jim Young"},{"$f":"[1]Boats!F22","v":72},{"$f":"[1]Boats!G22","v":72},{"$f":"[1]Boats!H22","v":72},{"$f":"[1]Boats!I22","v":72},{"$f":"[1]Boats!K22","v":"A"}]
[{"$f":"[1]Boats!A23","v":"Making Waves"},{"$f":"[1]Boats!B23","v":53229},{"$f":"[1]Boats!C23","v":"Frederick Burger"},{"$f":"[1]Boats!F23","v":174},{"$f":"[1]Boats!G23","v":177},{"$f":"[1]Boats!H23","v":174},{"$f":"[1]Boats!I23","v":177},{"$f":"[1]Boats!K23","v":"C"}]
[{"$f":"[1]Boats!A25","v":"One Trick Pony"},{"$f":"[1]Boats!B25","v":"US-188"},{"$f":"[1]Boats!C25","v":"David Meiser"},{"$f":"[1]Boats!F25","v":24},{"$f":"[1]Boats!G25","v":15},{"$f":"[1]Boats!H25","v":30},{"$f":"[1]Boats!I25","v":30},{"$f":"[1]Boats!K25","v":"A"}]
[{"$f":"[1]Boats!A26","v":"Patriot"},{"$f":"[1]Boats!B26","v":"USA25"},{"$f":"[1]Boats!C26","v":0},{"$f":"[1]Boats!F26","v":54},{"$f":"[1]Boats!G26","v":45},{"$f":"[1]Boats!H26","v":63},{"$f":"[1]Boats!I26","v":63},{"$f":"[1]Boats!K26","v":"A"}]
[{"$f":"[1]Boats!A27","v":"Pony Express"},{"$f":"[1]Boats!B27","v":50588},{"$f":"[1]Boats!C27","v":"Jimmy Yurko"},{"$f":"[1]Boats!F27","v":132},{"$f":"[1]Boats!G27","v":129},{"$f":"[1]Boats!H27","v":138},{"$f":"[1]Boats!I27","v":138},{"$f":"[1]Boats!K27","v":"B"}]
[{"$f":"[1]Boats!A28","v":"Pursuit"},{"$f":"[1]Boats!B28","v":23798},{"$f":"[1]Boats!C28","v":"Norm Dawley"},{"$f":"[1]Boats!F28","v":57},{"$f":"[1]Boats!G28","v":48},{"$f":"[1]Boats!H28","v":66},{"$f":"[1]Boats!I28","v":63},{"$f":"[1]Boats!K28","v":"A"}]
[{"$f":"[1]Boats!A29","v":"Rakali"},{"$f":"[1]Boats!B29","v":61145},{"$f":"[1]Boats!C29","v":"Mark Witte"},{"$f":"[1]Boats!F29","v":51},{"$f":"[1]Boats!G29","v":45},{"$f":"[1]Boats!H29","v":54},{"$f":"[1]Boats!I29","v":51},{"$f":"[1]Boats!K29","v":"A"}]
[{"$f":"[1]Boats!A30","v":"Shamal"},{"$f":"[1]Boats!B30","v":23827},{"$f":"[1]Boats!C30","v":"Jeff Carlsen"},{"$f":"[1]Boats!F30","v":174},{"$f":"[1]Boats!G30","v":174},{"$f":"[1]Boats!H30","v":174},{"$f":"[1]Boats!I30","v":174},{"$f":"[1]Boats!K30","v":"C"}]
[{"$f":"[1]Boats!A31","v":"SNUZULUZ"},{"$f":"[1]Boats!B31","v":327},{"$f":"[1]Boats!C31","v":"Caldwell / McKinney"},{"$f":"[1]Boats!F31","v":177},{"$f":"[1]Boats!G31","v":168},{"$f":"[1]Boats!H31","v":180},{"$f":"[1]Boats!I31","v":180},{"$f":"[1]Boats!K31","v":"C"}]
[{"$f":"[1]Boats!A32","v":"Spice"},{"$f":"[1]Boats!B32","v":154},{"$f":"[1]Boats!C32","v":"H G"},{"$f":"[1]Boats!F32","v":114},{"$f":"[1]Boats!G32","v":111},{"$f":"[1]Boats!H32","v":120},{"$f":"[1]Boats!I32","v":120},{"$f":"[1]Boats!K32","v":"B"}]
[{"$f":"[1]Boats!A33","v":"Splash"},{"$f":"[1]Boats!B33","v":"USA333"},{"$f":"[1]Boats!C33","v":"Tom Attick"},{"$f":"[1]Boats!F33","v":90},{"$f":"[1]Boats!G33","v":87},{"$f":"[1]Boats!H33","v":96},{"$f":"[1]Boats!I33","v":96},{"$f":"[1]Boats!K33","v":"A"}]
[{"$f":"[1]Boats!A34","v":"Stingray"},{"$f":"[1]Boats!B34","v":63383},{"$f":"[1]Boats!C34","v":"Elliot Peterson"},{"$f":"[1]Boats!F34","v":129},{"$f":"[1]Boats!G34","v":129},{"$f":"[1]Boats!H34","v":129},{"$f":"[1]Boats!I34","v":129},{"$f":"[1]Boats!K34","v":"B"}]
[{"$f":"[1]Boats!A35","v":"Stormy Petrel"},{"$f":"[1]Boats!B35","v":93644},{"$f":"[1]Boats!C35","v":"PAX"},{"$f":"[1]Boats!F35","v":168},{"$f":"[1]Boats!G35","v":168},{"$f":"[1]Boats!H35","v":168},{"$f":"[1]Boats!I35","v":168},{"$f":"[1]Boats!K35","v":"C"}]
[{"$f":"[1]Boats!A36","v":"Synergy"},{"$f":"[1]Boats!B36","v":83096},{"$f":"[1]Boats!C36","v":"Peter LaRoche"},{"$f":"[1]Boats!F36","v":168},{"$f":"[1]Boats!G36","v":168},{"$f":"[1]Boats!H36","v":168},{"$f":"[1]Boats!I36","v":168},{"$f":"[1]Boats!K36","v":"C"}]
[{"$f":"[1]Boats!A37","v":"Taerik"},{"$f":"[1]Boats!B37","v":30410},{"$f":"[1]Boats!C37","v":"Mardy Miller"},{"$f":"[1]Boats!F37","v":144},{"$f":"[1]Boats!G37","v":144},{"$f":"[1]Boats!H37","v":147},{"$f":"[1]Boats!I37","v":147},{"$f":"[1]Boats!K37","v":0}]
[{"$f":"[1]Boats!A38","v":"Tennacity"},{"$f":"[1]Boats!B38","v":173},{"$f":"[1]Boats!C38","v":"Bill Ward"},{"$f":"[1]Boats!F38","v":111},{"$f":"[1]Boats!G38","v":111},{"$f":"[1]Boats!H38","v":111},{"$f":"[1]Boats!I38","v":111},{"$f":"[1]Boats!K38","v":"B"}]
[{"$f":"[1]Boats!A39","v":"TENNOUNCE "},{"$f":"[1]Boats!B39","v":99},{"$f":"[1]Boats!C39","v":"John McKinney"},{"$f":"[1]Boats!F39","v":180},{"$f":"[1]Boats!G39","v":180},{"$f":"[1]Boats!H39","v":180},{"$f":"[1]Boats!I39","v":180},{"$f":"[1]Boats!K39","v":"C"}]
[{"$f":"[1]Boats!A40","v":"The Doghouse"},{"$f":"[1]Boats!B40","v":63199},{"$f":"[1]Boats!C40","v":"Dan Shannon"},{"$f":"[1]Boats!F40","v":111},{"$f":"[1]Boats!G40","v":111},{"$f":"[1]Boats!H40","v":111},{"$f":"[1]Boats!I40","v":111},{"$f":"[1]Boats!K40","v":"B"}]
[{"$f":"[1]Boats!A41","v":"Triton's Fury"},{"$f":"[1]Boats!B41","v":499},{"$f":"[1]Boats!C41","v":"T. J. O'Farrell"},{"$f":"[1]Boats!F41","v":252},{"$f":"[1]Boats!G41","v":252},{"$f":"[1]Boats!H41","v":252},{"$f":"[1]Boats!I41","v":252},{"$f":"[1]Boats!K41","v":"C"}]
[{"$f":"[1]Boats!A42","v":"USA 4201"},{"$f":"[1]Boats!B42","v":4201},{"$f":"[1]Boats!C42","v":"Terry Reese"},{"$f":"[1]Boats!F42","v":171},{"$f":"[1]Boats!G42","v":171},{"$f":"[1]Boats!H42","v":171},{"$f":"[1]Boats!I42","v":171},{"$f":"[1]Boats!K42","v":"C"}]
[{"$f":"[1]Boats!A43","v":"Whirlaway"},{"$f":"[1]Boats!B43","v":73211},{"$f":"[1]Boats!C43","v":"Frank Walter"},{"$f":"[1]Boats!F43","v":114},{"$f":"[1]Boats!G43","v":114},{"$f":"[1]Boats!H43","v":114},{"$f":"[1]Boats!I43","v":114},{"$f":"[1]Boats!K43","v":"B"}]
[{"$f":"[1]Boats!A44","v":"Wicked Good"},{"$f":"[1]Boats!B44","v":93121},{"$f":"[1]Boats!C44","v":"Mark Gyorgy"},{"$f":"[1]Boats!F44","v":132},{"$f":"[1]Boats!G44","v":132},{"$f":"[1]Boats!H44","v":132},{"$f":"[1]Boats!I44","v":132},{"$f":"[1]Boats!K44","v":"B"}]
[{"$f":"[1]Boats!A45","v":"Wild Horses"},{"$f":"[1]Boats!B45","v":"USA 222"},{"$f":"[1]Boats!C45","v":"McKinney, Caldwell"},{"$f":"[1]Boats!F45","v":24},{"$f":"[1]Boats!G45","v":15},{"$f":"[1]Boats!H45","v":30},{"$f":"[1]Boats!I45","v":30},{"$f":"[1]Boats!K45","v":"A"}]
[{"$f":"[1]Boats!A46","v":"Wild Thing"},{"$f":"[1]Boats!B46","v":87638},{"$f":"[1]Boats!C46","v":"Jimmy Yurko"},{"$f":"[1]Boats!F46","v":186},{"$f":"[1]Boats!G46","v":186},{"$f":"[1]Boats!H46","v":186},{"$f":"[1]Boats!I46","v":186},{"$f":"[1]Boats!K46","v":"C"}]
[{"$f":"[1]Boats!A47","v":0},{"$f":"[1]Boats!B47","v":0},{"$f":"[1]Boats!C47","v":0},{"$f":"[1]Boats!F47","v":0},{"$f":"[1]Boats!G47","v":0},{"$f":"[1]Boats!H47","v":0},{"$f":"[1]Boats!I47","v":0},{"$f":"[1]Boats!K47","v":0}]
[]
[]
[]
[]
[]
[null,null,"Boats without Handicap ratings will be scored with a 0 rating.  Scores will be updated when the Provisional Handicap is assigned."]